import pandas as pd

df = pd.read_excel('../static/data/2023地震数据.xlsx')
df['year'] = df['发震时刻'].apply(lambda x: int(x.split('-')[0]))
df['month'] = df['发震时刻'].apply(lambda x: int(x.split('-')[1]))
df.to_csv('../static/data/info_clean.csv', index=False)


